Re: Storing UNICODE data in DB

Bartos wrote:
> Hello.
>
> Does enyone knows, how to write data in russian or ukrainian to oracle
> table ( ver 9.2.0.5)?
> How to set NLS_LANG on client machine i how to set NLS parameters of DB ?
> Now i have on the server
> NLS_CHARACTERSET is AL32UTF8
> NLS_NCHAR_CHARACTERSET is AL16UTF16
> and on client
> NLS_LANG = UKRAINIAN_UKRAINE.CL8MSWIN1251
>
> I think that the database could store data in Unicode.But i have problem
> with writing data to DB.
> SQLPlus in place of CYR fonts writes "?". How to write data in unicode ?
>
>
> Thank for help.
>
> Bartos.
>
>

What sqlplus - Command Line or Windows version? If command line, change used font (properties of the CLI window, font).

Your server might have been setup with CL8MSWIN1252 as well, if ukrainian and russian are single byte charactersets. Not sure there. Now you have a multibyte characterset, meaning a varchar2(10) will probably not store 10 characters.
As the default is in byte, you can either: - change the default (lookup character semantics) - specify you want characters, not byte (varchar2(10 CHAR)).

-- 
Regards,
Frank van Bortel

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