How to insert all types of special char in database table

• sk.panda

  Right there with Babe

  Points: 796

  More actions

  November 25, 2010 at 12:18 pm

  #231600

  Dear All,

  I have a table and i want to allow all the special character insert into that table.

  But it causes problem for insert the data in database table for some special character senario.

  CREATE TABLE #test

  (

  test_col VARCHAR(20)

  )

  INSERT INTO #test([test_col])VALUES ('sh&&?34')

  INSERT INTO #test([test_col])VALUES ('sh&&?!@#$%^&*()_+- ?"'')

  Please suggest for the needful.

  Thanks in advance.

  Thanks and Regards,

  Sumanta Panda

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  November 25, 2010 at 1:25 pm

  #1255642

  In your example, the problem was unclosed single quote. If you have single quote, you will have to handle it by enclosing it in another set of single quotes.

  If you want to store all kind of special chars and different languages (Accents, tilts), then do not use varchar. Use nVarchar.

  -Roy

• LutzM

  SSC Guru

  Points: 107049

  More actions

  November 25, 2010 at 1:29 pm

  #1255645

  There are several questions:

  1) what do you consider being a "special character"? Do you have just a list of character, a rule on how to define it or a list considered as "not special"?

  2) If you define a column as VARCHAR(20), you cannt insert 22 character (like you posted in your sample)

  3) If you'd like to insert a single quotation mark within a string, it needs to be presented as two single quotation marks ('' instead of '). But make sure to use two single and not a double quotation mark...

  4) What are you trying to achieve? (there might be easier solutions available...)

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]