AW: Why Not MySQL?
| От | Zeugswetter Andreas SB |
|---|---|
| Тема | AW: Why Not MySQL? |
| Дата | |
| Msg-id | 219F68D65015D011A8E000006F8590C604AF7D6A@sdexcsrv1.f000.d0188.sd.spardat.at обсуждение исходный текст |
| Список | pgsql-hackers |
> "In a nutshell I want to use postgres as a back end to an access > database. This means that all collation done by postgres musht be case > insensitive including like clauses." > > I left the all the spelling mistakes in place :) Could a national char implementation that is case insensitive be a solution here ? Meaning: is it as simple as setting LC_COLLATE to another value and configuring --enable-locale ? How far is Thomas with the nchar nvarchar types ? I think national char and national char varying are the correct datatypes for such behavior. Although I think the = operator is still case sensitive for that datatype. Replacing = or like for the char and varchar or text datatypes is probably not possible, because it is used internally, but for nchar ... it should be. Andreas
В списке pgsql-hackers по дате отправления: