[DiscordArchive] I was wondering : in `npc_text` table we often have either NULL or '' in values.
[DiscordArchive] I was wondering : in `npc_text` table we often have either NULL or '' in values.
Archived author: Elmsroth • Posted: 2024-02-20T10:25:02.648000+00:00
Original source
I was wondering : in `npc_text` table we often have either NULL or '' in values.
is it an inconsistent format of there should be NULL everywhere it is '' ?
Archived author: Elmsroth • Posted: 2024-02-20T10:25:35.903000+00:00
Original source
There is no point putting empty quote if it is not explicitly needed in fact ?
![[Image: image.png?ex=690c780f&is=690b268f&hm=f56...b7c67477f&]](https://cdn.discordapp.com/attachments/369084351129845760/1209446212831285308/image.png?ex=690c780f&is=690b268f&hm=f56489e71af13773105d696a6dc7d44656756fb86f11b5d13d01206b7c67477f&)
Archived author: Elmsroth • Posted: 2024-02-20T10:27:27.726000+00:00
Original source
![[Image: image.png?ex=690c780f&is=690b268f&hm=f56...b7c67477f&]](https://cdn.discordapp.com/attachments/369084351129845760/1209446212831285308/image.png?ex=690c780f&is=690b268f&hm=f56489e71af13773105d696a6dc7d44656756fb86f11b5d13d01206b7c67477f&)
Archived author: Honey • Posted: 2024-02-20T10:58:59.484000+00:00
Original source
Appears to be just inconsistent I guess.
Archived author: Elmsroth • Posted: 2024-02-20T11:37:44.865000+00:00
Original source
That's what I thought... ;D
Archived author: Elmsroth • Posted: 2024-02-20T11:37:53.406000+00:00
Original source
fix incoming....
Archived author: Elmsroth • Posted: 2024-02-20T11:38:31.066000+00:00
Original source
I have alkready found 1k+ new translations for FR npc_text
Archived author: Elmsroth • Posted: 2024-02-20T11:38:57.141000+00:00
Original source
the analysis query is big though !
Archived author: Elmsroth • Posted: 2024-02-20T11:39:45.824000+00:00
Original source
because the table format is a pain in the ***... with textN_0, textN_1 with N from 0 to 7...
Archived author: Elmsroth • Posted: 2024-02-20T11:40:27.250000+00:00
Original source
the nice part is that mangos sources of WOtlkl have the same format so that's easy to compare and filter missing values.