473,320 Members | 2,029 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 2032
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: 321ConTact | last post by:
I have to find zipcodes within a given mileage range (25, 50, etc). I know it's possible to use the longitude/latitude to find this, and I have that for the zipcodes, but does anyone have a "ready...
1
by: Galsaba | last post by:
I am trying to find a script to a "dealer locator" or "find a store near you". I will have two tables. One will include all US and Canada ZIPs including lat and longtitudes. The other one is a...
11
by: hoopsho | last post by:
Hi Everyone, I am trying to write a program that does a few things very fast and with efficient use of memory... a) I need to parse a space-delimited file that is really large, upwards fo a...
0
by: Frank | last post by:
I have been learning asp.net with the help of IBuySpy store. It is a really good starter kit for beginner like me. The only problem is that it doesn't comes with a Store Admin module. Anyone has...
1
by: serge | last post by:
Right now the database I am working with is storing time in an Integer data type and is storing the time value in seconds. The application does not allow entering seconds. It accepts minutes and...
3
by: Indiresh | last post by:
Hi all, I have a problem downloading web pages to my local system. I am using the HttpebRequest class to query a web site and get the response from the same. UndNow, when i asy a web page, all...
2
by: martin-g | last post by:
Hi. Almost every application have to write out some messages to the user. The question is how to store them. For example, while programming for Windows in C++ we could store these messages as...
0
by: gamzeliii | last post by:
hi there I am new for java, i need hep store information for calendar like when u clicking date u can add information i have calendar codes which is mostly working but i dont know how i can store...
1
by: inadsad | last post by:
Dear Group, I have a store procedure with 12 input parameter and 2 output parameters I'm wondering what's the best way to simplify the following routine. I'd like to eliminate extra line of...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.