Hi,
Recently I restored a database from 7.4.1 (RHAS3.0) to 8.0.3
(RHAS4.0), and now we are running into locale issues:
[22:03] WARN SECUserDAO () - Problem retrieving user by username.
org.sourceforge.jxutil.sql.I18nSQLException: sqlError[invalid multibyte
character for locale]
…
Tom Lane wrote:
I don't know what behavior you thought you were getting from upper/lower
on UTF-8 data in 7.4, but it was surely not correct. If you want to
duplicate that misbehavior, try SQL_ASCII with C locale. This does not
stop you from storing UTF-8 in your database, mind you --- it just
lo
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Thursday, February 24, 2005 10:16 AM
To: Bjoern Metzdorf
Cc: Pgsql-Admin (E-mail)
Subject: Re: [ADMIN] invalid multibyte character for locale
Bjoern Metzdorf <[EMAIL PROTECTED]> writes:
> Is 8.0 just stricter or is
Bjoern Metzdorf <[EMAIL PROTECTED]> writes:
> Is 8.0 just stricter or is this just a side effect
> of your fix for multibyte upper/lower problem for locale != C?
Both those statements are true.
> If 7.3 and 7.4 behaviour is intended, is there a way to let 8.0 behave
> the same?
I don't know wh
Tom Lane wrote:
Well, in that case your encoding is indeed at variance with your locale
setting ;-). Perhaps you should declare the encoding as SQL_ASCII.
The immediate problem is that mbstowcs() is being called and it
evidently doesn't know what to do in C locale. SQL_ASCII (or any
single-byte
Bjoern Metzdorf <[EMAIL PROTECTED]> writes:
> CREATE INDEX foobar_uvalue_key ON foobar USING btree
> (upper((value)::text));
> ERROR: invalid multibyte character for locale
> HINT: The server's LC_CTYPE locale is probably incompatible with the
> database encoding.
> I forgot to say that I am u
I forgot to say that I am using UNICODE for database encoding (initdb -E
UNICODE and createdb -E UNICODE).
Bjoern Metzdorf wrote:
Hi,
I am testdriving postgresql 8.0.1.
On importing my old dump which works fine on 7.4.6 I am getting errors
like this one:
CREATE INDEX foobar_uvalue_key ON foobar
Hi,
I am testdriving postgresql 8.0.1.
On importing my old dump which works fine on 7.4.6 I am getting errors
like this one:
CREATE INDEX foobar_uvalue_key ON foobar USING btree (upper((value)::text));
ERROR: invalid multibyte character for locale
HINT: The server's LC_CTYPE locale is probably
