| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Tomi NA <hefest(at)gmail(dot)com> |
| Cc: | Martins Mihailovs <martins(dot)mihailovs(at)europrojects(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: UTF-8 |
| Date: | 2006-10-13 07:50:04 |
| Message-ID: | 20061013075004.GA1896@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Oct 12, 2006 at 11:09:53PM +0200, Tomi NA wrote:
> 2006/10/12, Martijn van Oosterhout <kleptog(at)svana(dot)org>:
> >On Tue, Oct 10, 2006 at 11:49:06AM +0300, Martins Mihailovs wrote:
> >> There are some misunderstood. Im using Linux 2.6.16.4, postgresql 8.1.4,
> >> (there are one of locale: lv_LV.utf8, for Latvian language). But if I
> >> want do "lower", then with standard latin symbols all is ok, but with
> >> others special symbols (like umlaut in Germany) there is problems, and
> >> sorting is going not like alphabet but like latin alphabet and specials
> >> symbols after. :(
> >
> >You don't say what your encoding is. If it not UTF-8, that's your
> >problem...
>
> Doesn't lv_LV.utf8 mean he *did* say what his encoding is?
Not really. It says the encoding the system *expects*. However, if he
actually created his database with LATIN1 encoding, it would explain
the problems he's having.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martins Mihailovs | 2006-10-13 07:50:52 | Re: UTF-8 |
| Previous Message | Albe Laurenz | 2006-10-13 07:23:29 | Re: looping through query to update column |