Re: [SQL] UTF8 encoding and non-text data types

2008-01-14 Thread dmp
Hi Steve, Have you tried converting to a decimal type or cast for the cost field? If you are gathering this data from a text field and placing in a variable of type string then using that variable in the insert statement it may be rejected because it is not type decimal. This has been my

Re: [SQL] UTF8 encoding and non-text data types

2008-01-14 Thread dmp
Sorry this should have been addressed to Medi dana. Hi Steve, Have you tried converting to a decimal type or cast for the cost field? If you are gathering this data from a text field and placing in a variable of type string then using that variable in the insert statement it may be rejected