clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1228849 fiddles created (16650 in the last week).

-- The MySQL version of this can be found at: -- https://dbfiddle.uk/?rdbms=mysql_5.6&fiddle=0361b593f9dd9926b69fd09c308694bd -- Related DBA.StackExchange Q&A: -- https://dba.stackexchange.com/a/269015/30859
 hidden batch(es)


-- DROP TABLE dbo.a; CREATE TABLE dbo.a ( i INT NOT NULL IDENTITY(1, 1) PRIMARY KEY, b VARCHAR(255) COLLATE Latin1_General_100_CI_AS_SC_UTF8 ); INSERT INTO dbo.[a] ([b]) VALUES (N'あ A い I う U え E お O.'), (N'想看什頭清只傷精,中美觀的接委主們認可易畫等助海因'); INSERT INTO dbo.[a] ([b]) VALUES (0xE38182204120E38184204920E38186205520E38188204520E3818A204F2E);
3 rows affected
 hidden batch(es)


SELECT [b], LEN([b]) AS [LEN()], DATALENGTH([b]) AS [DATALENGTH()] FROM dbo.[a];
b LEN() DATALENGTH()
あ A い I う U え E お O. 20 30
想看什頭清只傷精,中美觀的接委主們認可易畫等助海因 25 75
あ A い I う U え E お O. 20 30
 hidden batch(es)