Storing Indic numerals in mySQL database

[swto]

Hi All,

I'm trying to store Indic numbers in mySQL within a numeric column. However, when I submit it via my form (php), the stored value defaults to a zero (0). I can only seem to store them in a TEXT/VARCHAR column. My table, etc. is in utf-8.

My questions:
Is there are workaround for this? What have others done about this issue?

Thanks in advance!

[Dan Grossman]

A symbol that happens to be a number in some language is no more a number to the database than the word "nine". Convert the text to an integer, then store it.

[swto]

Thanks, Dan -

Does this mean I run a convert function for my columns that use indic numbers?

For example - SELECT convert('indic#' AS UNSIGNED INTEGER).

[swto]

Hi Dan and everyone,

I'm having a bit of trouble figuring this out.

I'm attempting to change the column type for this - but not sure if this is correct, date=field:

date convert(date AS UNSIGNED INTEGER)

I am doing this in mysql while constructing the table, but can't get it to work. Am I on the right track?

Thanks!

[Dan Grossman]

Indic numerals are some kind of characters in an extended character set that represent numbers in a specific language, yes? MySQL doesn't know anything about all that, you need to do the conversion yourself

[swto]

I see what you mean --
Thanks, Dan