# 🏷️SQL更新URT单位

目前在**更新codelist**后，会使urt部分**单位**出现乱码，解决方法如下，使用下列SQL语句，更新**Unit**表

其中有问题的单位 UnitID：3,4,13,20,21,22,23,32,33,53,61,63,68,69,73,80,109,124,125,157

### SQL语句

```sql
UPDATE [dbo].[Unit] SET [Name] = N'µg/mL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 3;
UPDATE [dbo].[Unit] SET [Name] = N'µEq/mL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 4;

UPDATE [dbo].[Unit] SET [Name] = N'µg/dL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 13;

UPDATE [dbo].[Unit] SET [Name] = N'M/µL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 20;
UPDATE [dbo].[Unit] SET [Name] = N'K/µL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 21;
UPDATE [dbo].[Unit] SET [Name] = N'per µL', [Flag] = N'C' WHERE [LanguageID] = 1 AND [UnitID] = 22;
UPDATE [dbo].[Unit] SET [Name] = N'fL (cubic Âµm)', [Flag] = N'CS' WHERE [LanguageID] = 1 AND [UnitID] = 23;

UPDATE [dbo].[Unit] SET [Name] = N'PPM (µg/g, mg/kg)', [Flag] = N'CS' WHERE [LanguageID] = 1 AND [UnitID] = 32;
UPDATE [dbo].[Unit] SET [Name] = N'µIU/mL', [Flag] = N'CS' WHERE [LanguageID] = 1 AND [UnitID] = 33;

UPDATE [dbo].[Unit] SET [Name] = N'µmol/L', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 53;

UPDATE [dbo].[Unit] SET [Name] = N'PPB (ng/g, µg/kg)', [Flag] = N'CS' WHERE [LanguageID] = 1 AND [UnitID] = 61;

UPDATE [dbo].[Unit] SET [Name] = N'µg/L', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 63;

UPDATE [dbo].[Unit] SET [Name] = N'µmol/mol', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 68;
UPDATE [dbo].[Unit] SET [Name] = N'µmol/L/sec', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 69;

UPDATE [dbo].[Unit] SET [Name] = N'µg/L/hr', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 73;

UPDATE [dbo].[Unit] SET [Name] = N'µkat/L', [Flag] = N'S' WHERE [LanguageID] = 1 AND [UnitID] = 80;

UPDATE [dbo].[Unit] SET [Name] = N'µmol/Ejaculate', [Flag] = N'CS' WHERE [LanguageID] = 1 AND [UnitID] = 109;

UPDATE [dbo].[Unit] SET [Name] = N'copies/µL', [Flag] = N'' WHERE [LanguageID] = 1 AND [UnitID] = 124;
UPDATE [dbo].[Unit] SET [Name] = N'µmol/mL', [Flag] = N'' WHERE [LanguageID] = 1 AND [UnitID] = 125;

UPDATE [dbo].[Unit] SET [Name] = N'μU/mL', [Flag] = N'RE' WHERE [LanguageID] = 1 AND [UnitID] = 157;

```
