SqlBase Characterset

[MSpecht]

Hello,
is it possible to define a characterset for the normal Columns(NOT National- e.g. VARCHAR...) like in Oracle:
NLS_CHARACTERSET = AL32UTF8
NLS_NCHAR_CHARACTERSET = UTF8
NLS_LENGTH_SEMANTICS = CHAR

With this setting we don't must use the NVARCHAR2 Column and we can use the Oracle VARCHAR2 Column with UNICODE, because the hole database is UNICODE and the VARCHAR2 columns are stored als Character and not by Byte.
This setting helps us alot because we don't must change every SqlStatement in our code.

So is this possible with the SqlBase 11.6 too?

[Mike Vandine]

Would you want this for a specific column or are you looking for the whole database?

Have a look at the NLS support that we do using the country.sql file in the DBA Guide. Also look at the 'characterset' statement for the sql.ini file in the same manual.

Hope this helps!

[MSpecht]

hmmm,

if you mean this: https://support.guptatechnologies.com/Do ... s.html#277,
this don't help alot...
We would need something to set the hole Database as UNICODE without change our source to NVarchar...