Hi Peter,

I'll gladly chip in for more coffee for you! ;-)

Thanks for the reply. I'm basically trying to evaluate how we are going to
move to DBCS support in one of our applications, so this is more research
at the moment than trying to implement anything. We have the same app that
will be installed in different locations. Thankfully it appears that we
will have specific languages to support (not just "any"), so I'm thinking I
can change to Unicode and then add different language collations - I guess
some of this will have to happen at install time depending on their
location.

> Also note, that using a correct locale specific sort order,
> will also limit the index lengths to 1/3 of binary sort order,
> even for 8 bit character sets.

Okay, you lost me on that one! Will this change with 2.0?

Thanks for your help,

Cheers,

David







"peter_jacobi.rm" <peter_jacobi@...> on 13/11/2003 03:33:01 AM

Please respond to firebird-support@yahoogroups.com

To: firebird-support@yahoogroups.com
cc:
Subject: [firebird-support] Re: Unicode Support


Hi David,

--- In firebird-support@yahoogroups.com, dhay@l... wrote:
> Just a few more questions, if you don't mind:

In the moment I only mind, that I have to
brew fresh coffes :-)

> > Getting a middle layer involved (JDBC, ODBC or .NET) will give
> > you the choice of a wide character interface, AFAIK.
> Do you/anyone know if JDBC and ODBC drivers currently support unicode?

Please ask on the specialised lists, I cannot give
informed feedback.
http://sourceforge.net/mail/?group_id=9028
http://groups.yahoo.com/group/Firebird-Java/

> > 2. Using UTF-8 with 1..3 bytes/chars gives limits on field
> > sizes and index lengths only 1/3 of those using a plain
> > 8 bit charset.
> Do you know if these limits will be changed with an upcoming release?
> That's pretty restrictive

As far as I understood, the index length limits will
be raised.

Also note, that using a correct locale specific sort order,
will also limit the index lengths to 1/3 of binary sort order,
even for 8 bit character sets.

I better stop now, before I become even more confusing?

Perhaps you tell us more about the data you want to store
and we can then give better advise what to do?

Regards,
Peter Jacobi




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/