Hello,
I'm running delphi 7
I use TSQLConnection with MySQL Direct driver (I'm a registered customer)
I also use MySQL server 4.1.10, with UTF8 as default character set.
When sending queries that contains strings, it seems that the string is truncated or not passed correctly - so the query has very strange results
If the character set of the MySQL server is set to Latin1, then I have no problem.
Is there any explanation or workaround ?
utf8 support ?
If to work in this charset all string data before passing to the server must be converted by UTF8Encode, and on retrieve at client side - by UTF8Decode. As dataware controls don't support UTF8, this charset is used in Delphi very seldom.
Now we are working on release a new MyDAC version that will in Unicode = True mode return all strings as WideString. But this way is not applicable in dbExpress as it doesn't support WideString fields.
> Is there any explanation or workaround ?
Use another (not Unicode) charset.
Now we are working on release a new MyDAC version that will in Unicode = True mode return all strings as WideString. But this way is not applicable in dbExpress as it doesn't support WideString fields.
> Is there any explanation or workaround ?
Use another (not Unicode) charset.