The ANSI character set is very important for operating MSSQL, if no conversion,will attract more C# users

via Digitalmars-d digitalmars-d at puremagic.com
Thu Jan 15 08:03:45 PST 2015


On Thursday, 15 January 2015 at 14:50:29 UTC, FrankLike wrote:
> The wstring displayed ok in cmd,but not ok in gui(must use the 
> fromMBS fuction),so I want to test change the gui'control.d 
> ,set text property is Tstring ,by verstion(ANSI),set text is 
> wstring ,else ,set text is string.

Ah, ok.

Just keep in mind that if you see missing characters it might be 
the configuration of your client library that is the problem 
since newer versions of MSSQL should use UCS2 during transfer. 
Some libraries convert to less capable character sets such as 
iso-8859-1 by default.

I believe each varchar column in the database can have a 
different character set since the database scheme can specify the 
collation, but nvarchar columns use UCS2. It is generally a good 
idea to look over your schema and see what is specified if you 
cannot support unicode.


More information about the Digitalmars-d mailing list