Oninit cdi / Archive
Talk to an expert →

Re: Problem with UTF8 and Default Roles

Posted in 2007

Topics: Server Administration, Security, Permissions & Auditing, Platform-Specific Issues, Internationalization & Character Sets

Thomas J. Girsch — — source: Usenet: comp.databases.informix

Fernando Nunes wrote: > Thomas J. Girsch wrote: >> Can anyone else replicate this? I get a -23103 error when trying to >> use dbschema on a UTF8 database that contains default roles. If the >> database is not UTF8, everything works fine. >> >> I've replicated it on 10.00.UC6, FC5, FC6, FC7 on Solaris, AIX, and >> Linux. I have a PMR open, but the engineer working the case has so >> far been UNABLE to replicate it. > > Yes... I could do it... I just had to change the LANG variable to > en_US.8859-1 > Repeat your test with LANG=en_US.UTF-8 or set your CLIENT_LOCALE to utf8 > > Apparently it's related to field defrole from the sysusers table, but to > be honest it's too late for me... > Please make some tests, tell the engineer about it and eventually give > us some feedback. > Regards, > > According to our support engineer, they've reproduced it at IBM and are entering a defect for this.

↪ replying to Thomas J. Girsch
Jean Georges Perrin — — source: Usenet: comp.databases.informix

Is it the UTF-8-probalem-part-of-the-year, I also have an issue ;-)... SQL Error: -79783 - Encoding or codeset not supported I have a UTF database, running fine on the server with: SERVER_LOCALE=en_US.utf8 DB_LOCALE=en_US.utf8 I connect to the engine using JDBC (and Hibernate) through a standard Java connection string: jdbc:informix-sqli://xxxxx:9088/xxxx:informixserver=xxx;DB_LOCALE=en_us.utf8 ;CLIENT_LOCALE=en_us.utf8 Connection goes ok, most of the operations go ok, but sometimes, it fails with the SQL Error I report... I must admit I am not super familiar (yet ;-) ) with UTF-8 / GLS / I18N so any help/tip would be helpful. Thanks, jgp > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Thomas J. Girsch > Sent: Wednesday, November 07, 2007 06:26 > To: informix-list@iiug.org > Subject: Re: Problem with UTF8 and Default Roles > > Fernando Nunes wrote: > > Thomas J. Girsch wrote: > >> Can anyone else replicate this? I get a -23103 error when trying to > >> use dbschema on a UTF8 database that contains default roles. If the > >> database is not UTF8, everything works fine. > >> > >> I've replicated it on 10.00.UC6, FC5, FC6, FC7 on Solaris, AIX, and > >> Linux. I have a PMR open, but the engineer working the case has so > >> far been UNABLE to replicate it. > > > > Yes... I could do it... I just had to change the LANG variable to > > en_US.8859-1 > > Repeat your test with LANG=en_US.UTF-8 or set your CLIENT_LOCALE to > utf8 > > > > Apparently it's related to field defrole from the sysusers table, but > to > > be honest it's too late for me... > > Please make some tests, tell the engineer about it and eventually > give > > us some feedback. > > Regards, > > > > > > According to our support engineer, they've reproduced it at IBM and are > entering a defect for this. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Jean Georges Perrin
Fernando Nunes — — source: Usenet: comp.databases.informix

Jean Georges Perrin wrote: > Is it the UTF-8-probalem-part-of-the-year, I also have an issue ;-)... > > SQL Error: -79783 - Encoding or codeset not supported > > I have a UTF database, running fine on the server with: > SERVER_LOCALE=en_US.utf8 > DB_LOCALE=en_US.utf8> > I connect to the engine using JDBC (and Hibernate) through a standard Java > connection string: > > jdbc:informix-sqli://xxxxx:9088/xxxx:informixserver=xxx;DB_LOCALE=en_us.utf8 > ;CLIENT_LOCALE=en_us.utf8 > > Connection goes ok, most of the operations go ok, but sometimes, it fails > with the SQL Error I report... > > I must admit I am not super familiar (yet ;-) ) with UTF-8 / GLS / I18N so > any help/tip would be helpful. > > Thanks, > > jgp Version of IDS, version of JDBC driver, using blobs or not, can you reproduce it? Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

↪ replying to Fernando Nunes
Jean Georges Perrin — — source: Usenet: comp.databases.informix

Sorry, I thought I did that... All last version... IDS 11.1xc1 linux 64 Jdbc 3.10.jc1 Not using Blobs, difficult to reproduce on a small example for now... Tx jgp > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of Fernando Nunes > Sent: jeudi 8 novembre 2007 00:09 > To: informix-list@iiug.org > Subject: Re: Problem with UTF8 and Default Roles > > Jean Georges Perrin wrote: > > Is it the UTF-8-probalem-part-of-the-year, I also have an issue ;- > )... > > > > SQL Error: -79783 - Encoding or codeset not supported > > > > I have a UTF database, running fine on the server with: > > SERVER_LOCALE=en_US.utf8 > > DB_LOCALE=en_US.utf8> > > > I connect to the engine using JDBC (and Hibernate) through a standard > Java > > connection string: > > > > jdbc:informix- > sqli://xxxxx:9088/xxxx:informixserver=xxx;DB_LOCALE=en_us.utf8 > > ;CLIENT_LOCALE=en_us.utf8 > > > > Connection goes ok, most of the operations go ok, but sometimes, it > fails > > with the SQL Error I report... > > > > I must admit I am not super familiar (yet ;-) ) with UTF-8 / GLS / > I18N so > > any help/tip would be helpful. > > > > Thanks, > > > > jgp > > > Version of IDS, version of JDBC driver, using blobs or not, can you > reproduce it? > > Regards. > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

Related threads