Problem with UTF8 and Default Roles

[Thomas J. Girsch]

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.

Here's what you need to do:

$ export DB_LOCALE=en_US.utf8
$ dbaccess -a sysmaster << EOF

CREATE DATABASE testdb WITH BUFFERED LOG;
GRANT CONNECT TO "tgirsch";
CREATE ROLE "ifmxdba";
EOF

Database selected.


Database closed.


Database created.


Permission granted.


Role created.



Database closed.

$ dbschema -d testdb -ss

DBSCHEMA Schema Utility INFORMIX-SQL Version 10.00.FC6
Copyright IBM Corporation 1996, 2006 All rights reserved
Software Serial Number AAA#B000000
grant dba to "informix";
grant connect to "tgirsch";

create role "ifmxdba" ;


revoke usage on language SPL from public ;

grant usage on language SPL to public ;


$ dbaccess testdb << EOF

GRANT DEFAULT ROLE "ifmxdba" TO "tgirsch";
EOF

Database selected.


Permission granted.



Database closed.

$ dbschema -d testdb -ss

DBSCHEMA Schema Utility INFORMIX-SQL Version 10.00.FC6
Copyright IBM Corporation 1996, 2006 All rights reserved
Software Serial Number AAA#B000000
grant dba to "informix";
grant connect to "tgirsch";

create role "ifmxdba" ;

grant "ifmxdba" to "tgirsch" ;

-23103 - Code-set conversion function failed due to illegal sequence or
invalid value.

A repeat test with DB_LOCALE unset shows that everything works fine, then:

$ dbaccess sysmaster << EOF

DROP DATABASE testdb;
EOF

Database selected.


Database dropped.



Database closed.

$ unset DB_LOCALE
$ dbaccess sysmaster << EOF

CREATE DATABASE testdb WITH BUFFERED LOG;
GRANT CONNECT TO "tgirsch";
CREATE ROLE "ifmxdba";
EOF

Database selected.


Database closed.


Database created.


Permission granted.


Role created.



Database closed.

$ dbschema -d testdb -ss

DBSCHEMA Schema Utility INFORMIX-SQL Version 10.00.FC6
Copyright IBM Corporation 1996, 2006 All rights reserved
Software Serial Number AAA#B000000
grant dba to "informix";
grant connect to "tgirsch";

create role "ifmxdba" ;



revoke usage on language SPL from public ;

grant usage on language SPL to public ;


$ dbaccess testdb << EOF

GRANT DEFAULT ROLE "ifmxdba" TO "tgirsch";
EOF

Database selected.


Permission granted.



Database closed.

$ dbschema -d testdb -ss

DBSCHEMA Schema Utility INFORMIX-SQL Version 10.00.FC6
Copyright IBM Corporation 1996, 2006 All rights reserved
Software Serial Number AAA#B000000
grant dba to "informix";
grant connect to "tgirsch";

create role "ifmxdba" ;

grant "ifmxdba" to "tgirsch" ;

grant default role "ifmxdba" to "tgirsch" ;

revoke usage on language SPL from public ;

grant usage on language SPL to public ;

$

[Fernando Nunes]

Post by Thomas J. Girsch
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,

[Thomas J. Girsch]

Post by Fernando Nunes

Post by Thomas J. Girsch
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.

[Jean Georges Perrin]

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-----
Sent: Wednesday, November 07, 2007 06:26
Subject: Re: Problem with UTF8 and Default Roles

Post by Fernando Nunes

Post by Thomas J. Girsch
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

Post by Fernando Nunes
Apparently it's related to field defrole from the sysusers table, but

to

Post by Fernando Nunes
be honest it's too late for me...
Please make some tests, tell the engineer about it and eventually

give

Post by Fernando Nunes
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
http://www.iiug.org/mailman/listinfo/informix-list

[Fernando Nunes]

Post by Jean Georges Perrin
Is it the UTF-8-probalem-part-of-the-year, I also have an issue ;-)...
SQL Error: -79783 - Encoding or codeset not supported
SERVER_LOCALE=en_US.utf8
DB_LOCALE=en_US.utf8
I connect to the engine using JDBC (and Hibernate) through a standard Java
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.

[Jean Georges Perrin]

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-----
Sent: jeudi 8 novembre 2007 00:09
Subject: Re: Problem with UTF8 and Default Roles

Post by Jean Georges Perrin
Is it the UTF-8-probalem-part-of-the-year, I also have an issue ;-

)...

Post by Jean Georges Perrin
SQL Error: -79783 - Encoding or codeset not supported
SERVER_LOCALE=en_US.utf8
DB_LOCALE=en_US.utf8
I connect to the engine using JDBC (and Hibernate) through a standard

Java

Post by Jean Georges Perrin
jdbc:informix-

sqli://xxxxx:9088/xxxx:informixserver=xxx;DB_LOCALE=en_us.utf8

Post by Jean Georges Perrin
;CLIENT_LOCALE=en_us.utf8
Connection goes ok, most of the operations go ok, but sometimes, it

fails

Post by Jean Georges Perrin
with the SQL Error I report...
I must admit I am not super familiar (yet ;-) ) with UTF-8 / GLS /

I18N so

Post by Jean Georges Perrin
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
http://www.iiug.org/mailman/listinfo/informix-list

[Jonathan Leffler]

Post by Thomas J. Girsch
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.

I can reproduce it with IDS 10.00.UC5 on Solaris 10.
I cannot reproduce it with IDS 11.10.FC1 on Solaris 10.
That suggests an obvious workaround. :)

Suggest to your support engineer that they contact me.

-=JL=-