Electrical Symbols - Ohms - micro

Hi,
would anyone be able to point me in the right direction on how to save
the
electrical symbols for ohms and micro in a sql server field.
Many thanks,Make sure you use NVARCHAR, and pass the character in a string with the N
prefix.
CREATE TABLE dbo.foo
(
symbol NVARCHAR(32)
);
GO
INSERT dbo.foo
SELECT N''; -- not sure if this will be correct in your newsreader
GO
SELECT symbol FROM dbo.foo;
GO
DROP TABLE foo;
GO
"Jedawi" <jedawi@.hotmail.co.uk> wrote in message
news:eK9ZVWkBGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi,
> would anyone be able to point me in the right direction on how to save
> the
> electrical symbols for ohms and micro in a sql server field.
> Many thanks,
>
>|||Many thanks Aaron, works a treat..
Cheers
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uVLElYkBGHA.1008@.TK2MSFTNGP12.phx.gbl...
> Make sure you use NVARCHAR, and pass the character in a string with the N
> prefix.
> CREATE TABLE dbo.foo
> (
> symbol NVARCHAR(32)
> );
> GO
> INSERT dbo.foo
> SELECT N''; -- not sure if this will be correct in your newsreader
> GO
> SELECT symbol FROM dbo.foo;
> GO
> DROP TABLE foo;
> GO
>
>
> "Jedawi" <jedawi@.hotmail.co.uk> wrote in message
> news:eK9ZVWkBGHA.1288@.TK2MSFTNGP09.phx.gbl...
>