RE: Problem with UTF8 and Default Roles

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@xxxxxxxx [mailto:informix-list-
bounces@xxxxxxxx] On Behalf Of Thomas J. Girsch
Sent: Wednesday, November 07, 2007 06:26
To: informix-list@xxxxxxxx
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@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list

.

Relevant Pages

  • RE: Database Deployment ?
    ... I don't see I can reverse engine a Database in Visual Studio. ... SQL Server, e.g. stored procedures, functions, triggers and etc. ... Microsoft Online Community Support ... Engineer within 1 business day is acceptable. ...
    (microsoft.public.vsnet.general)
  • RE: two sql statement questions
    ... even if you're connecting to a database through ... Not all database supports multiple SQL statements. ... Microsoft Online Community Support ... Engineer within 1 business day is acceptable. ...
    (microsoft.public.data.odbc)
  • Re: How do you make decisions that optimize software quality?
    ... > total cost of development and deployment - that means, ... > would strain my ability to be low cost AND high quality? ... You are asking how to be a Software Engineer... ... Create a sample database, put sample data in it, call production code to ...
    (comp.object)
  • Re: How do you make decisions that optimize software quality?
    ... > total cost of development and deployment - that means, ... > would strain my ability to be low cost AND high quality? ... You are asking how to be a Software Engineer... ... Create a sample database, put sample data in it, call production code to ...
    (comp.lang.java.softwaretools)
  • Re: Oracle Directconnect (ODC) Security - is it ok?
    ... connected for the period that they're available for support activity. ... and select the appropriate engineer from a dropdown list. ... If the session can truly be locked down by the customer to be viewing ... Disaffected employees at the Support Company (Oracle) or ExpertCity ...
    (comp.security.misc)