Get UNICODE_LE charset actual value

[tramesh2009]

Hi,

We've Multilanguage requirement in our application. To support this in Interbase Database table field
We've specified the Data type as Varchar(400) Charset as UNICODE_LE.

We saved Chineese Character in this field When we try fetch it is not returning chineese format
It returns in Different format.

Thank you
Rameshkumar T

[jeffovercash]

Are you setting the character set in the connection string? While the original Fb code did not have any unit tests around this, I did look at the code and it should be translating back and forth. I'll be writing some unit tests, but I know with IBX and FireDAC to work with non-ANSI data you need to set the lc_ctype in hte connection string and with the ADO>NET driver that is the character set parameter.

[tramesh2009]

Hi,
We got the solution to save and retrieve unicode value by using this driver. The following steps we are used to achieve this concept
Field Name : Unicode_text
Data Type : Varchar(400)
Charset : Unicode_LE

Retrieve Concepts:
byte[] bytes = Encoding.Default.GetBytes(<DB Field Name>); var fieldValue = Encoding.UTF8.GetString(bytes);

Save Concepts:
byte[] byteValue = Encoding.UTF8.GetBytes(actualValue); fieldValue =Encoding.Default.GetString(byteValue);

We should add charset=UTF8 in the connection string for this table fetch and save

Thank You

[jeffovercash]

7.12.1 release goes back to the way most drivers work and that is no charset is none, not UTF8 (the API is none if the lc_ctype is not set). So with the no charset being set tramesh2009's workaround should not be needed.