[DiscordArchive] space as separation sign?
[DiscordArchive] space as separation sign?
Original source
So i need to convert values to bytes and combine just like flags?
rektbyfaith
01-12-2025, 02:21 PM #11Archived author: ERINGAR • Posted: 2025-01-12T14:21:09.164000+00:00
Original source
So i need to convert values to bytes and combine just like flags?
Original source
Can i pls make an example for this data? If u have some free time
![[Image: image.png?ex=690c068c&is=690ab50c&hm=44c...7da79e5ea&]](https://cdn.discordapp.com/attachments/376457124726702080/1328006354970873896/image.png?ex=690c068c&is=690ab50c&hm=44c1ef409cbd8e07fedf72565db978b782b7a56fba0b9b400f9a4937da79e5ea&)
rektbyfaith
01-12-2025, 02:23 PM #12Archived author: ERINGAR • Posted: 2025-01-12T14:23:08.292000+00:00
Original source
Can i pls make an example for this data? If u have some free time
Original source
0x4241434B5041434B5F544F4F4C544950004261636B7061636B0005
rektbyfaith
01-12-2025, 02:24 PM #13Archived author: Tea • Posted: 2025-01-12T14:24:17.487000+00:00
Original source
0x4241434B5041434B5F544F4F4C544950004261636B7061636B0005
Original source
Ty man, now i'll try to make it by myself ❤️
rektbyfaith
01-12-2025, 02:26 PM #14Archived author: ERINGAR • Posted: 2025-01-12T14:26:11.553000+00:00
Original source
Ty man, now i'll try to make it by myself ❤️
Original source
Okay, it works perfect. If someone need it, it's something like this
```py
# GlobalStrings.py
def generate(str0, str1, byte):
blob_data = (
str0.encode('utf-8') + b'\x00' +
str1.encode('utf-8') + b'\x00' +
bytes([byte]))
return "0x" + blob_data.hex().upper();
```
rektbyfaith
01-12-2025, 02:52 PM #15Archived author: ERINGAR • Posted: 2025-01-12T14:52:12.313000+00:00
Original source
Okay, it works perfect. If someone need it, it's something like this
```py
# GlobalStrings.py
def generate(str0, str1, byte):
blob_data = (
str0.encode('utf-8') + b'\x00' +
str1.encode('utf-8') + b'\x00' +
bytes([byte]))
return "0x" + blob_data.hex().upper();
```
Original source
Is there a performance difference between working with implemented tables via hotfix_data and working via hotfix_blob? If I have, in theory, several tens of thousands of hotfixes, is there a difference between these two methods?
rektbyfaith
01-12-2025, 03:08 PM #16Archived author: ERINGAR • Posted: 2025-01-12T15:08:57.478000+00:00
Original source
Is there a performance difference between working with implemented tables via hotfix_data and working via hotfix_blob? If I have, in theory, several tens of thousands of hotfixes, is there a difference between these two methods?
Original source
no
rektbyfaith
01-12-2025, 03:09 PM #17Archived author: Tea • Posted: 2025-01-12T15:09:20.448000+00:00
Original source
no
Original source
Hm... looks like working with blobs is much easier
rektbyfaith
01-12-2025, 03:10 PM #18Archived author: ERINGAR • Posted: 2025-01-12T15:10:16.855000+00:00
Original source
Hm... looks like working with blobs is much easier
Original source
the distinction is very simple - separate tables for db2 files worldserver needs to run (and i maintain their db structure) and blob for everything else (where i dont want to bother updating their structure/finding out new column names on every patch)
rektbyfaith
01-12-2025, 03:10 PM #19Archived author: Tea • Posted: 2025-01-12T15:10:45.021000+00:00
Original source
the distinction is very simple - separate tables for db2 files worldserver needs to run (and i maintain their db structure) and blob for everything else (where i dont want to bother updating their structure/finding out new column names on every patch)
Original source
Interesting. In that case, I'll probably use blobs in the future. At least, I won't have to waste time implementing tables, and the amount of SQL code will be much less. Thanks again for explaining everything so clearly!
rektbyfaith
01-12-2025, 03:13 PM #20Archived author: ERINGAR • Posted: 2025-01-12T15:13:05.379000+00:00
Original source
Interesting. In that case, I'll probably use blobs in the future. At least, I won't have to waste time implementing tables, and the amount of SQL code will be much less. Thanks again for explaining everything so clearly!
1 Guest(s)
1 Guest(s)