Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

March 18, 2021
3:22 pm
RogerW
Guest
Guests

Thanks Henk,
I changed it to nvarchar(100) and it worked. Now it's possible to create an index to search quickly on
MessageLog.MessageGuid.

Regards RogerW.

March 18, 2021
2:44 pm
Henk Helmantel
Admin
Forum Posts: 1312
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Roger,

You can limit the field length in the database, for example to nvarchar(40) to be able to store formatted GUID strings. That does not change the way Diafaan SMS Server handles the information in the field. The nvarchar(max) field type is just a suggestion to indicate that Diafaan SMS Server can handle large strings in the MessageGuid field, but this is not a requirement.

Regards, Henk

March 18, 2021
12:44 pm
RogerW
Guest
Guests

Hi
I have recently bought and installed a new version of Diafaan. Our previous version was from approx 2012.
We have previously been able to "join" MessageOut and MessageLog by setting a guid into the UserInfo field.
I think MessageGuid now could be used for that. Unfortunately I saw that MessageGuid had the same datatype as UserInfo, ie nvarchar(max) which can't be used in an index.
Can I somehow recreate the tables and use another datatype for MessageGuid or how does it work?
This is not critical as one can use an indexed MessageTo (phone-number) in the join and thereby get a quite good join, but of course the datatype of MessageGuid shouldnt be nvarchar(max), should it?

Kind regards RogerW.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 616

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1024

Posts: 3513

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1312