Re: nlssort problem

MadeOfRose schreef:
> thanks
>
> i set the environment variable and it is working fine.
>
> know i have another problem about the turkish characters
>
> my database's character set is 'windows 1254'. When i use the INSERT
> INTO with oracle raptor all the special characters seem well.
> But, when i use the oracle oledb drivers with ASP (via ADO) , special
> characters seem like question mark.
> is there any way to determine character set to OLEDB.I could not find
> the connection string parameter.
> (i wanna use this character set because we have an ERP software and
> this ASP site is going to work integrated with it.
> they will communicate via XML files.And our ERP database use 8 bit
> character set.)
>
> Thank you
> regards
>

Usually not a problem of the drivers, or tools, but the ability of the program to display these characters. You front-end does not understand them, and displays a question mark.

Try opening a command line interface ("DOS-box"); perform the select - probably you will see the same "wrong" results. Now open the properties of the CLI, open the Fonts tab, and select Lucinda Console for font. If your select does not display correctly, exit you SQL, type 'chcp 1254', and retry. Betcha it works!

chcp, by the way, stands for change code page.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...