Do your realy need to know the differenz ? take everything as "string".
(breaks with pics/geodata but helps a lot).
re,
wh
sangprabv schrieb:
> Hi,
> I found no built in function in mysql to check whether a record is
> numeric or string. Is there any trick to do so? Many thanks.
>
>
>
>
> Wi
Only in the case you want to know the datatype and not the actual type of
information in a char field!
If you issue:
show fields from MyTable like 'FName';
you get:
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--
> From: sangprabv
> Subject: is_string or is_numeric
> To: [email protected]
> Date: Thursday, 15 October, 2009, 10:34 AM
> Hi,
> I found no built in function in mysql to check whether a
> record is
> numeric or string. Is there any trick to do so? Many
> thanks.
You could use some regex to d
