Unicode comment on Postgres vs Sql Server

Поиск
Список
Период
Сортировка
От Swaminathan Saikumar
Тема Unicode comment on Postgres vs Sql Server
Дата
Msg-id 82692d4a0803021150lb63ab9akd074e21e097deeb@mail.gmail.com
обсуждение исходный текст
Ответы Re: Unicode comment on Postgres vs Sql Server  (Stephane Bortzmeyer <bortzmeyer@nic.fr>)
Re: Unicode comment on Postgres vs Sql Server  (Tino Wildenhain <tino@wildenhain.de>)
Re: Unicode comment on Postgres vs Sql Server  ("Leif B. Kristensen" <leif@solumslekt.org>)
Список pgsql-general
I am familiar with MS Sql Server & just started using Postgres.
For storing Unicode, Sql Server uses nvarchar/char for unicode, and uses char/varchar for ASCII.
Postgres has this encoding setting at the database level.

I am using UTF8 Unicode for most of my data, but there is some data that I know for sure will be ASCII. However, this is also stored as UTF8, using up more space.

At first sight, it looks like the the more granular level design is better. Any comments? If you agree, does it make sense to add this as a new datatype to Postgres?

Thanks

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Understanding ps -ef "command" column
Следующее
От: "Swaminathan Saikumar"
Дата:
Сообщение: Design suggestion of multiple databases vs multiple schemas within the database