Re: International Language Supplement

Terence Chang <tat_mun@dbs.com.sg> writes: > > Hi, > One of my production server running ODS 7.23 UC4 on AIX 4.2 > encounters a "illegal character error" when performing some sql > statements via Peoplesoft. > When I checked with Peoplesoft, they claimed that the International > Language Supplement may not be installed. What's this international > language supplement? Isn't it the GLS (global language support)? How > can I activate this international language support. The environment > variable LANG is set to en_US and the DBNLS is not set at all. > Any help is greatly appreciated. What I have done on the databases where we *need* latin1 characters is to create the database with the following defined in the environment: LC_CTYPE=swedish.iso88591 LC_COLLATE=swedish.iso88591 DBNLS=2 # it works with DBNLS=1 too When running the application, I've had to drop the DBNLS environment variable, but that might have changed with 7.2[23]. It didn't, however, work under 7.20 (at least dbaccess didn't, complained about locale mismatch or something like that). If you have an existing database, you will have to export, drop and re-import it. //Ingvar (waiting for a better solution to locale changes...) -- Sysadmin, disgruntled, unpolite. I don't speak for my employer nor do they speak for me. Accept this and life will be easier. ingvar@idasys.se