"YL" <elim@xxxxxxxxxxxxxxx> writes: > I'm migrating from mysql to postgresql. > I've several (mysql)tables with multi-language columns: > > descript, descript_gb, descript_b5, descript_sp > > they store the record's description in > English, SimplifiedChinese, TraditionalChinese and Spanish respectively. > > I don't know if this will work in postgresql: I need to query those > columns > (one language at a time). And I hope the contents in those columns > can be displayed in web (one language at a time) easily. > > Any suggestions? Thanks I don't think this will be a problem, as long as you use UNICODE (UTF-8) for the database encoding. -Doug ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend