Difference between SQL and SQL Unicode

Yahoo Archive
1
Unicode has larger database sizes. Unicode requires more room to support multi-language because of the method it stores its characters.

Normal ASCII is fine for most installs.

Here is a great article that I read a while back and kept in my favorites:
http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=275

It explains it all.



Vic



Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Mobile:Â 704.530.3092
Office:Â 336.668.4410 x3159


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rojas, Joe
Sent: Tuesday, March 31, 2009 3:36 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Difference between SQL and SQL Unicode

Is there a down-side to selecting Unicode if, like in our case, we only
need to support US English?



Joe



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ned C
Sent: Monday, March 30, 2009 8:13 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Difference between SQL and SQL Unicode



I think the best way to describe it would be that it uses the Unicode
character
set for all the information in the database versus a standard ASCII
character
set, which allows for a wider range of languages to be kept in the DB
natively.

Long Story short, unless you require Chinese or other "complicated"
characters
in your DB then there is no need to install the Unicode version.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Deepa
Sent: Monday, March 30, 2009 3:01 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Difference between SQL and SQL Unicode

Hi,

Good morning, Will you please tell me what is the difference between SQL
and SQL
Unicode?
As I found during Installation of Epicor 9.04 there are three options,
among
that one is Installation of Sql for Windows and the another is Sql
Unicode for
Windows.

Thank you & Regards,
Deepa.M

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
Hi,

Good morning, Will you please tell me what is the difference between SQL and SQL Unicode?
As I found during Installation of Epicor 9.04 there are three options, among that one is Installation of Sql for Windows and the another is Sql Unicode for Windows.

Thank you & Regards,
Deepa.M




[Non-text portions of this message have been removed]
3
I think the best way to describe it would be that it uses the Unicode character
set for all the information in the database versus a standard ASCII character
set, which allows for a wider range of languages to be kept in the DB natively.

Long Story short, unless you require Chinese or other "complicated" characters
in your DB then there is no need to install the Unicode version.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Deepa
Sent: Monday, March 30, 2009 3:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Difference between SQL and SQL Unicode

Hi,

Good morning, Will you please tell me what is the difference between SQL and SQL
Unicode?
As I found during Installation of Epicor 9.04 there are three options, among
that one is Installation of Sql for Windows and the another is Sql Unicode for
Windows.

Thank you & Regards,
Deepa.M




[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
4
Hi Ned,
Thank You for your support
Regards,
Deepa.MÂ

________________________________
From: Ned C <TechnoBabbly@...>
To: vantage@yahoogroups.com
Sent: Monday, March 30, 2009 4:12:39 PM
Subject: RE: [Vantage] Difference between SQL and SQL Unicode


I think the best way to describe it would be that it uses the Unicode character
set for all the information in the database versus a standard ASCII character
set, which allows for a wider range of languages to be kept in the DB natively.

Long Story short, unless you require Chinese or other "complicated" characters
in your DB then there is no need to install the Unicode version.

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Deepa
Sent: Monday, March 30, 2009 3:01 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Difference between SQL and SQL Unicode

Hi,

Good morning, Will you please tell me what is the difference between SQL and SQL
Unicode?
As I found during Installation of Epicor 9.04 there are three options, among
that one is Installation of Sql for Windows and the another is Sql Unicode for
Windows.

Thank you & Regards,
Deepa.M

[Non-text portions of this message have been removed]

------------ --------- --------- ------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links







[Non-text portions of this message have been removed]
5
Is there a down-side to selecting Unicode if, like in our case, we only
need to support US English?



Joe



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ned C
Sent: Monday, March 30, 2009 8:13 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Difference between SQL and SQL Unicode



I think the best way to describe it would be that it uses the Unicode
character
set for all the information in the database versus a standard ASCII
character
set, which allows for a wider range of languages to be kept in the DB
natively.

Long Story short, unless you require Chinese or other "complicated"
characters
in your DB then there is no need to install the Unicode version.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Deepa
Sent: Monday, March 30, 2009 3:01 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Difference between SQL and SQL Unicode

Hi,

Good morning, Will you please tell me what is the difference between SQL
and SQL
Unicode?
As I found during Installation of Epicor 9.04 there are three options,
among
that one is Installation of Sql for Windows and the another is Sql
Unicode for
Windows.

Thank you & Regards,
Deepa.M

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]