question

santhanakumar04 avatar image
santhanakumar04 asked

SQL SERVER: impact analysis of storing special characters instead of alphabets in TABLE VALUES

I have a table where i have a scenario to store the <,>,<=,>= symbols in tables.

Is it fine or should i use 'greater than','less than','greater than equal to','less than equal to' as table values

tsqlsqlserver
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Any body please share your view please?

0 Likes 0 ·

I can't think of any impact. Doesn't it depend on what you need those values for?

0 Likes 0 ·

They're just ascii characters, so they'll be stored like any other characters, there will be no performance impact. ====> you'll be fine <====== :) :P

If you've got something special to do with them then you may want to consider something else. Here's a guess at how you might want to use them... a flag field and use a case statement:

  CASE WHEN YourGreaterThanFlag = 1 THEN '>'
		ELSE '<' END

Hope that helps.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.