🚀 go-pugleaf

Hi

Thanks for your input !.

MS SQL supports unicode with their nchar , nvarchar etc , but the BDE does
not understand
these column types.

I am assuming that MCBS is possibly translatable on the fly , but I am not
sure if the BDE will
do something funny when it gets MCBS , I will scratch around some more , and
if I find someting I will post it here.

Regards

Robi


"William Meyer" <wmhmeyer@earthlink.net> wrote in message
news:3bf33ed5$1_2@dnews...
> "Robi Kihm" <robi_kihm@yebo.co.za> wrote in message
news:3bf193f9_2@dnews...
> >
> > I need to translate an app into Chinese. I see that there are components
> > (TsiLang is one of them)
> > that will help translate the user interface.
> >
> > BUT , I need to be able to store chinese characters using BDE into MS
SQL
> > Server 7.
> >
> > How would I go about setting this up ?.
> >
> > It looks as if the VCL (TDBEdit etc) do support entering chinese
> characters
> > ( I did a copy and
> > paste from the win2k character map into a dbedit field on my apps ui ,
and
> > it did display a valid
> > chinese character in the dbedit text box) but when I save this record
and
> > refresh , the chinese character is displayed as a ?. I set up chinese
> > language support on win2k and set the locale etc etc to chinese
>
> There are other translation components, and there are also component packs
> which are compatible with Unicode. (ElPack from ElDos is one such.)
>
> I think that the safest solution for storing strings in the database will
> probably be to translate their form, to and from the storage. One of the
> issues you need to verify is support for MBCS in SQL Server.
>
> > Any help would really be appreciated , especially since I do not know
> where
> > to start !
>
> If My answers are of no help, or if they cover ground you have already
> explored, I am sorry, but I am also working to uncover answers to MBCS
> issues.
>
> You may wish to explore here:
>
> http://www.delphi-unicode.net/
>
> http://www.efg2.com/Lab/OtherProjects/Unicode.htm
>
> I hope this helps.
>
> Bill
>
>
>