Delimiting 2 values
Posted on 2006-05-31
I am storing some values in a particular column in database table (database - MS SQLServer). The 2 values are delimited by #.
User is provided a text field, where he can enter values. When this form is submitted, then a value ispicked up from the session and the value entered by the user is appended to it (# delimiter is used) and stored in the database.
Now I have been suggested to use a tabulator character ("\t") instead, since it can never be entered by the user in the text field.
When I see the value in the database it shows a square type of character inplace of tabular character. I want to know it is the right way to do this stuff or should i recommend going back to "#". Also when I get that value from the database, how can I break them into their original form.