casting Bangla characters to NUMERIC
| От | Bob Jolliffe |
|---|---|
| Тема | casting Bangla characters to NUMERIC |
| Дата | |
| Msg-id | CACd=f9e+D_m=hTm9fV-hoMG4CDjo6qw0Z4Uk3peUhCOR=O+caA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: casting Bangla characters to NUMERIC
|
| Список | pgsql-general |
Hi
I have an interesting problem. I have a string field in a table which
(sometimes) is expected to contain numeric values ie. a cast of the
field to INTEGER is supposed to succeed.
My issue is that the application is running in Bangladesh, and
sometimes the users have entered values using Bangla characters. eg.
"৮" rather than "8". (Note that this shouldnt have been possible to
enter in the first place, but we can ignore that for now. They are
there, I have to somehow deal with it.)
Is there a way with LOCALE settings to get this cast to work
correctly? Currently I get:
postgres=# select cast('৮' as INTEGER);
ERROR: invalid input syntax for integer: "৮"
LINE 1: select cast('৮' as INTEGER);
Regards
Bob
В списке pgsql-general по дате отправления: