DEV Community

Kaziu
Kaziu

Posted on • Updated on

๐Ÿคจ How to change character code on Mac?

๐Ÿ’Ž I got sql file from friend who uses Windows

But I could not execute it on my Mac because of character error

Windows Mac
Shift JIS UTF-8

โ–ผ Japanese characters are corrupted

INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(1,'2010/07/23 12:19:45','ono1','shinichi1','1-a-1','โˆšโ€ขยฌร‡ยฌรดโˆšยฎยฌร„ยฌร‰AAAAAA1')
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(2,'2010/07/23 12:20:45','ono2','shinichi2','1-a-2','โˆšโ€ขยฌร‡ยฌรดโˆšยฎยฌร„ยฌร‰AAAAAA2')
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(3,'2010/07/23 12:21:45','ono3','shinichi3','1-a-3','โˆšโ€ขยฌร‡ยฌรดโˆšยฎยฌร„ยฌร‰AAAAAA3')
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(4,'2010/07/23 12:22:45','ono4','shinichi4','1-a-4','โˆšโ€ขยฌร‡ยฌรดโˆšยฎยฌร„ยฌร‰AAAAAA4')
...
Enter fullscreen mode Exit fullscreen mode

๐Ÿ’Ž How to resolve it?

install nkf

$ brew install nkf

// check file character code
$ nkf -g file.sql
Shift_JIS

// I wanna change to UTF-8
$ nkf -w --overwrite file.sql
Enter fullscreen mode Exit fullscreen mode

then resolved !

INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(1,'2010/07/23 12:19:45','ono1','shinichi1','1-a-1','ๅ‚™่€ƒAAAAAA1')
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(2,'2010/07/23 12:20:45','ono2','shinichi2','1-a-2','ๅ‚™่€ƒAAAAAA2')
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(3,'2010/07/23 12:21:45','ono3','shinichi3','1-a-3','ๅ‚™่€ƒAAAAAA3')
INSERT INTO Shain(Id,CreateDate,Sei,Mei,Tel,Bikou) VALUES(4,'2010/07/23 12:22:45','ono4','shinichi4','1-a-4','ๅ‚™่€ƒAAAAAA4')
Enter fullscreen mode Exit fullscreen mode

Top comments (2)

Collapse
 
spo0q profile image
spO0q ๐Ÿ’๐ŸŽƒ

Thanks for sharing I did not know this kanji code converter.

Collapse
 
kaziusan profile image
Kaziu

You're welcome !