Error message problem
Posted: Fri 23 Aug 2019 08:00
There is a problem with the error message
MariaDB has an problem with the error message(strange Characters Are Visible)
PostgreSQL is no problem
use Delphi 10.3, unidac 8.0.1
1. DB : MariaDB(setting to utf8)
SQL : SIGNAL SQLSTATE '90116' SET MESSAGE_TEXT = '你好안녕¡Buenos días!';
UniConnection1.SpecificOptions.Values['MySQL.UseUnicode'] := 'True';
except on E:EUniError do begin
E.Message rerult ==> #90116你�??�녕¡Buenos días!
2. DB : PostgreSQL(setting to utf8)
SQL : do $$
begin
RAISE EXCEPTION '%', '你好안녕¡Buenos días!' ;
end;
$$
UniConnection1.SpecificOptions.Values['PostgreSQL.UseUnicode'] := 'True';
except on E:EUniError do begin
E.Message rerult ==> 你好안녕¡Buenos días!
MariaDB has an problem with the error message(strange Characters Are Visible)
PostgreSQL is no problem
use Delphi 10.3, unidac 8.0.1
1. DB : MariaDB(setting to utf8)
SQL : SIGNAL SQLSTATE '90116' SET MESSAGE_TEXT = '你好안녕¡Buenos días!';
UniConnection1.SpecificOptions.Values['MySQL.UseUnicode'] := 'True';
except on E:EUniError do begin
E.Message rerult ==> #90116你�??�녕¡Buenos días!
2. DB : PostgreSQL(setting to utf8)
SQL : do $$
begin
RAISE EXCEPTION '%', '你好안녕¡Buenos días!' ;
end;
$$
UniConnection1.SpecificOptions.Values['PostgreSQL.UseUnicode'] := 'True';
except on E:EUniError do begin
E.Message rerult ==> 你好안녕¡Buenos días!