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 ;

$

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,


--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

On Nov 1, 3:57 pm, 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.

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=-

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.

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

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...

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