Question regarding UTF-8 data and "C" collation on definition of field of table

Поиск
Список
Период
Сортировка
От Dionisis Kontominas
Тема Question regarding UTF-8 data and "C" collation on definition of field of table
Дата
Msg-id CAB4Evu1nV57hohRkEzs3J5MtDOzLFo-Uo-_TtLbiUB1WEFVOxw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Question regarding UTF-8 data and "C" collation on definition of field of table  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Question regarding UTF-8 data and "C" collation on definition of field of table  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
Hello all,

  I have a question regarding the definition of the type of a character field in a table and more specifically about its collation and UTF-8 characters and strings.

  Let's say that the definition is for example as follows:

    name character varying(8) COLLATE pg_catalog."C" NOT NULL

and also assume that the database default encoding is UTF8 and also the Collate and Ctype is "C"". I plan to store strings of various languages in this field.

Are these the correct settings that I should have used on creation of the database?. 

Thank you in Advance!

Kindest regards,

Dionisis Kontominas

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

Предыдущее
От: Erik Wienhold
Дата:
Сообщение: Re: Slow down dev database transactions/second for testing?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Question regarding UTF-8 data and "C" collation on definition of field of table