469,090 Members | 1,100 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Store Gitar Codes

Hi
Is there any way to store gitar codes in sql server table. or want to
set specific "COLLATE".

Thanks
Dishan

Jul 23 '05 #1
7 1958
Personally, I have no idea what "gitar codes" are, but assuming you
have MSSQL 2000, you can select a default collation when you install
it; you can specify a database collation when you create or alter a
database; you can specify a column collation when you create or alter a
table; and you can use different collations dynamically in queries
using the COLLATE keyword.

Additionally, you can use Unicode data types to support Unicode
character data - see "Using Unicode Data" and "Collations" in Books
Online.

Simon

Jul 23 '05 #2
its guitar codes such as C# Bb

Jul 23 '05 #3
its guitar codes such as C# Bb

Jul 23 '05 #4
you have to implement this specific "collation" e.g. by defining table
like

CREATE TABLE NOTES(
POSITION tinyint NOT NULL PRIMARY KEY,
CODE varchar(5) not null
)

INSERT INTO NOTES (POSITION,CODE)
VALUES(1,'C1')
INSERT INTO NOTES (POSITION,CODE)
VALUES(2,'C#1')
--....

INSERT INTO NOTES (POSITION,CODE)
VALUES(12,'B1') --i'm not sure if B1 is 12th semitone
INSERT INTO NOTES (POSITION,CODE)
VALUES(13,'C2')
--....

Jul 23 '05 #5
Hi
No. What I want to do is insert C# as real Code. that means # character
little bit upper position. Can I do that?

DishanF

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 23 '05 #6
>No. What I want to do is insert C# as real Code. that means #
character
little bit upper position. Can I do that?


you gotta have a special font that is capable of it

http://www.clevelandorff.org/fonts/metdemo.GIF

Jul 23 '05 #7
A musical sharp is Unicode 266F (9839 decimal):

http://www.fileformat.info/info/unic...266f/index.htm

You can store this value in a column with a Unicode data type: nchar,
nvarchar, or ntext, but you'll also need to use a front end which can
display it correctly to a client.

Simon

Jul 23 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Frank | last post: by
2 posts views Thread by martin-g | last post: by
1 post views Thread by inadsad | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.