question

santhanakumar04 asked Feb 20, '19

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

tsql sqlserver

3

10 |1200

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

santhanakumar04 commented · Feb 21, 2019 at 02:17 PM

Any body please share your view please?

0 ·

Kev Riley ♦♦ commented · Feb 21, 2019 at 02:21 PM

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

0 ·

WRBI commented · Feb 21, 2019 at 02:57 PM

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 ·