Price wont show any letters only numbers

[TeLLe]

I have a script that has cars for sale and i would like the price to sometimes show N/A or PER/MONTH but the database wont show it at all... i even put it in manually through database but it wont show it at all... if there are no numbers it shows 0.00 and if there are numbers and letters like R 1000.00 per/month it only shows the R 1000.00 ??
I have no idea where to sort it out... i have been looking through the code but i cant seem to find anything... the database is VARCHAR ...

If anyone has any ideas please help..

TeLLe

 

[leroy30]

I'd say that database column is of a type that doesn't support characters. I.e. it is a number, currency, etc.

You could change it but whatever your software is doing it'll probably break it. If it's to do with price then it's property using the currency data type so it can perform logical currency calculations on the data.

Bottom line is you probably can't. Instead make a new column that houses the extra data you need.