> TI> Problem here is the result of convert(ort using utf_8_to_iso_8859_1) > TI> is ISO-8859-1 but your database encoding is UTF-8, > > Not exactly, my database is in iso_8859_1, only the opengeodb-dump is > solely available in utf-8. > The whole thing is no problem so far, as I can convert the values in > the application that uses the data - I just wanted to let you know.
That's surprising. Since you try to convert from UTF-8 to ISO 8859-1, I thought you store data as UTF-8. > TI> I guess what you want to do is: > TI> SELECT plz, loc_id, ort from orte_de > TI> where plz between 20000 and 30000 > TI> order by convert(ort using utf_8_to_iso_8859_1) > > Well, that was a fantasy-query :) just to show some "odd" values, I do > not need that much data in the application. Currently, I cannot > retrieve ready-converted iso data from the orte_de view, as converted > names that contain "ß" are not shown... Let me make sure. You store UTF-8 data in ISO 8859-1 DB? -- Tatsuo Ishii ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
